* Replaced LIMIT with limitResult call in rebuildrecentchanges.php

[lhc/web/wiklou.git] / maintenance / ora / tables.sql

diff --git a/maintenance/ora/tables.sql b/maintenance/ora/tables.sql
index 2ddadfe..9b08d00 100644 (file)
--- a/maintenance/ora/tables.sql
+++ b/maintenance/ora/tables.sql
@@ -680,3 +680,11 @@ EXCEPTION
 END;
 /*$mw$*/
 
+/*$mw$*/
+CREATE OR REPLACE FUNCTION GET_SEQUENCE_VALUE(seq IN VARCHAR2) RETURN NUMBER AS
+       v_value NUMBER;
+BEGIN
+       EXECUTE IMMEDIATE 'SELECT '||seq||'.NEXTVAL INTO :outVar FROM DUAL' INTO v_value;
+       RETURN v_value;
+END;
+/*$mw$*/